Ensuring production-safe DBtune

DBtune safety and automatic control policies

DBtune is safe to use in production environments, guardrails exist by design to protect against negative implications. These guardrails protect users from undesired downtime or undesirable performance degradation due to the DBtune product.

Total memory usage guardrail

DBtune implements a guardrail to monitor the total RAM usage during the tuning session. As a default behavior DBtune will automatically react and move away from PostgreSQL configurations that make the database instance use more than 90% available memory. This threshold is adjustable.

Mitigation of temporary low performance during the tuning process

DBtune implements a guardrail to monitor the performance of each database configuration that is used on the customer instance during the tuning session. If the performance in AQR of a server configuration is above 2 times the baseline configuration (e.g., 50ms -> 100ms), or the transactions per seconds (TPS) metric falls more than 95% of the original transactions per second, then DBtune automatically abandons that configuration by moving to the next iteration and recommending a new alternative configuration.